Hero image

Gemma Bolt's Shop

Average Rating4.52
(based on 62 reviews)

Enthusiastic Law graduate who has been teaching Law and Business since 2013. I have a passion for creating high quality resources to support my fellow teachers and make everyone's life a little easier.

231Uploads

60k+Views

127k+Downloads

Enthusiastic Law graduate who has been teaching Law and Business since 2013. I have a passion for creating high quality resources to support my fellow teachers and make everyone's life a little easier.
Assessment and Data Tracker/Analysis Spreadsheet - A-Level
gemmaboltgemmabolt

Assessment and Data Tracker/Analysis Spreadsheet - A-Level

(0)
This spreadsheet is a time saving resource for class teachers, heads of department and school leaders. Included is a ready formatted copy of the spreadsheet and a PDF ‘How to’ guide which breaks down and explains step-by-step. This PDF also offers answers to several FAQs and offers tips and advice. This spreadsheet is designed to allow class teachers and HoDs to easily monitor student progress over time and identify students for intervention. Once set up using the how-to guide, class teachers simply need to enter assessment grades and the Excel sheet automatically calculates whether each student is below, on or above target. The workbook also analyses data and breaks down the % of students above, achieving or below target for key groups such as SEND, PP, EAL, etc. This data can also broken down by each class in that year group. Please note this version is to be used with A-Level classes.
Assessment and Data Tracker/Analysis Spreadsheet - BTEC Subjects
gemmaboltgemmabolt

Assessment and Data Tracker/Analysis Spreadsheet - BTEC Subjects

(1)
This spreadsheet is a time saving resource for class teachers, heads of department and school leaders. Included is a ready formatted copy of the spreadsheet and a PDF ‘How to’ guide which breaks down and explains step-by-step. This PDF also offers answers to several FAQs and offers tips and advice. This spreadsheet is designed to allow class teachers and HoDs to easily monitor student progress over time and identify students for intervention. Once set up using the how-to guide, class teachers simply need to enter assessment grades and the Excel sheet automatically calculates whether each student is below, on or above target. The workbook also analyses data and breaks down the % of students above, achieving or below target for key groups such as SEND, PP, EAL, etc. This data can also broken down by each class in that year group. Please note this version is to be used with BTEC subjects.
Assessment and Data Tracker/Analysis Spreadsheet - Bundle
gemmaboltgemmabolt

Assessment and Data Tracker/Analysis Spreadsheet - Bundle

4 Resources
Combining all Assessment and Data Tracker options in one useful bundle at a reduced price, this is perfect if you teach multiple subjects or multiple exam levels. These spreadsheets are a time saving resource for class teachers, heads of department and school leaders. Included is a ready formatted copy of the spreadsheets and a PDF ‘How to’ guide which breaks down and explains step-by-step. This PDF also offers answers to several FAQs and offers tips and advice. This spreadsheet is designed to allow class teachers and HoDs to easily monitor student progress over time and identify students for intervention. Once set up using the how-to guide, class teachers simply need to enter assessment grades and the Excel sheet automatically calculates whether each student is below, on or above target. The workbook also analyses data and breaks down the % of students above, achieving or below target for key groups such as SEND, PP, EAL, etc. This data can also broken down by each class in that year group.
Assessment and Data Tracker/Analysis Spreadsheet - Single Entry Subjects
gemmaboltgemmabolt

Assessment and Data Tracker/Analysis Spreadsheet - Single Entry Subjects

(1)
This spreadsheet is a time saving resource for class teachers, heads of department and school leaders. Included is a ready formatted copy of the spreadsheet and a PDF ‘How to’ guide which breaks down and explains step-by-step. This PDF also offers answers to several FAQs and offers tips and advice. This spreadsheet is designed to allow class teachers and HoDs to easily monitor student progress over time and identify students for intervention. Once set up using the how-to guide, class teachers simply need to enter assessment scores and the Excel sheet automatically calculates percentages, grades and whether each student is below, on or above target. The workbook also analyses data and breaks down the % of students above, achieving or below target for key groups such as SEND, PP, EAL, etc. This data can also broken down by each class in that year group. Please note this version is best used with subjects that have only a single tier of entry (i.e. not foundation / higher subjects)
Assessment and Data Tracker/Analysis Spreadsheet - Higher/Foundation Subjects
gemmaboltgemmabolt

Assessment and Data Tracker/Analysis Spreadsheet - Higher/Foundation Subjects

(0)
This spreadsheet is a time saving resource for class teachers, heads of department and school leaders. Included is a ready formatted copy of the spreadsheet and a PDF ‘How to’ guide which breaks down and explains step-by-step. This PDF also offers answers to several FAQs and offers tips and advice. This spreadsheet is designed to allow class teachers and HoDs to easily monitor student progress over time and identify students for intervention. Once set up using the how-to guide, class teachers simply need to enter assessment scores and the Excel sheet automatically calculates percentages, grades and whether each student is below, on or above target. The workbook also analyses data and breaks down the % of students above, achieving or below target for key groups such as SEND, PP, EAL, etc. This data can also broken down by each class in that year group. Please note this version is best used with subjects that have multiple tier entry (i.e. foundation / higher subjects)